﻿using System;
using System.Data;
using System.Data.SqlClient;

namespace Web
{
    public class OnlineAPIDao
    {
        public  static string GetURL(int projectID)
        {
            SqlParameter[] parameters = new SqlParameter[1];
            parameters[0] = new SqlParameter("@ID",projectID);

            string sql = "Select URL From Project Where ID=@ID";

            return Convert.ToString(SqlHelper.ExecuteScalar(SqlHelper.OnlineAPIConnectionString, CommandType.Text, sql, parameters)); 
        }
    }
}